From 718dbf08cfb22b2104de44c456e49fe2402775ff Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 15 Jul 2026 16:31:02 +0000 Subject: [PATCH] Resolve conversion problem #101 by making NULL focals UNK --- conversion/clean.sql | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/conversion/clean.sql b/conversion/clean.sql index 807b06f..05983f6 100644 --- a/conversion/clean.sql +++ b/conversion/clean.sql @@ -561,3 +561,9 @@ UPDATE aggression_event UPDATE aggression_event SET ae_multiple_recipient_flag = NULL WHERE ae_multiple_recipient_flag = ' '; + + +-- Problem #101 +UPDATE aggression_event + SET ae_fol_b_focal_id = 'UNK' + WHERE ae_fol_b_focal_id IS NULL; -- 2.34.1